Tabela DiagnosisListItemStatus

Definicja tabeli DiagnosisListItemStatus

Name

DiagnosisListItemStatus

Code

DiagnosisListItemStatus

Comment

Zmiany statusu pacjenta na liscie chorób przewleklych


Lista kolumn tabeli DiagnosisListItemStatus

Name

Code

DiagnosisListItemStatusID

DiagnosisListItemStatusID

DiagnosisListItemID

DiagnosisListItemID

EventID

EventID

StatusID

StatusID

StartDT

StartDT

StatusComment

StatusComment

CurrentStatus

CurrentStatus


Kolumna DiagnosisListItemStatusID tabeli DiagnosisListItemStatus

Definicja kolumny DiagnosisListItemStatusID tabeli DiagnosisListItemStatus

Name

DiagnosisListItemStatusID

Code

DiagnosisListItemStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DiagnosisListItemID tabeli DiagnosisListItemStatus

Definicja kolumny DiagnosisListItemID tabeli DiagnosisListItemStatus

Name

DiagnosisListItemID

Code

DiagnosisListItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventID tabeli DiagnosisListItemStatus

Definicja kolumny EventID tabeli DiagnosisListItemStatus

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

pobyt/wizyta, z którego dodajemy/usuwamy pacjenta do/z listy chorób przewleklych


Kolumna StatusID tabeli DiagnosisListItemStatus

Definicja kolumny StatusID tabeli DiagnosisListItemStatus

Name

StatusID

Code

StatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

status pacjenta na liscie


Kolumna StartDT tabeli DiagnosisListItemStatus

Definicja kolumny StartDT tabeli DiagnosisListItemStatus

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

data wprowadzenia statusu


Kolumna StatusComment tabeli DiagnosisListItemStatus

Definicja kolumny StatusComment tabeli DiagnosisListItemStatus

Name

StatusComment

Code

StatusComment

Data Type

VARCHAR2(128)

Mandatory

No

Comment

komentarz dotyczacy ustawienia statusu


Kolumna CurrentStatus tabeli DiagnosisListItemStatus

Definicja kolumny CurrentStatus tabeli DiagnosisListItemStatus

Name

CurrentStatus

Code

CurrentStatus

Data Type

NUMBER(1)

Mandatory

Yes

Comment

 


Lista kluczy tabeli DiagnosisListItemStatus

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DiagnosisListItemStatus

Definicja klucza Identifier_1 tabeli DiagnosisListItemStatus

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment